<html>
    <head>
        <title>Docs For Class PHPExcel_Calculation_Financial</title>
        <link rel="stylesheet" type="text/css" href="../media/style.css">
    </head>
    <body>

        <table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
            <tr>
                <td class="header_top">PHPExcel_Calculation</td>
            </tr>
            <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
            <tr>
                <td class="header_menu">


                    [ <a href="../classtrees_PHPExcel_Calculation.html" class="menu">class tree: PHPExcel_Calculation</a> ]
                    [ <a href="../elementindex_PHPExcel_Calculation.html" class="menu">index: PHPExcel_Calculation</a> ]
                    [ <a href="../elementindex.html" class="menu">all elements</a> ]
                </td>
            </tr>
            <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
        </table>

        <table width="100%" border="0" cellpadding="0" cellspacing="0">
            <tr valign="top">
                <td width="200" class="menu">
                    <div id="todolist">
                        <p><a href="../todolist.html">Todo List</a></p>
                    </div>
                    <b>Packages:</b><br />
                    <a href="../li_PHPExcel.html">PHPExcel</a><br />
                    <a href="../li_com-tecnick-tcpdf.html">com-tecnick-tcpdf</a><br />
                    <a href="../li_JAMA.html">JAMA</a><br />
                    <a href="../li_Math_Stats.html">Math_Stats</a><br />
                    <a href="../li_PHPExcel_CachedObjectStorage.html">PHPExcel_CachedObjectStorage</a><br />
                    <a href="../li_PHPExcel_Calculation.html">PHPExcel_Calculation</a><br />
                    <a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
                    <a href="../li_PHPExcel_Chart.html">PHPExcel_Chart</a><br />
                    <a href="../li_PHPExcel_Chart_Renderer.html">PHPExcel_Chart_Renderer</a><br />
                    <a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
                    <a href="../li_PHPExcel_Reader_Excel5.html">PHPExcel_Reader_Excel5</a><br />
                    <a href="../li_PHPExcel_Reader_Excel2007.html">PHPExcel_Reader_Excel2007</a><br />
                    <a href="../li_PHPExcel_RichText.html">PHPExcel_RichText</a><br />
                    <a href="../li_PHPExcel_Settings.html">PHPExcel_Settings</a><br />
                    <a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
                    <a href="../li_PHPExcel_Shared_Escher.html">PHPExcel_Shared_Escher</a><br />
                    <a href="../li_PHPExcel_Shared_OLE.html">PHPExcel_Shared_OLE</a><br />
                    <a href="../li_PHPExcel_Shared_Trend.html">PHPExcel_Shared_Trend</a><br />
                    <a href="../li_PHPExcel_Shared_ZipArchive.html">PHPExcel_Shared_ZipArchive</a><br />
                    <a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
                    <a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
                    <a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
                    <a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
                    <a href="../li_PHPExcel_Writer_Excel5.html">PHPExcel_Writer_Excel5</a><br />
                    <a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
                    <br /><br />
                    <b>Files:</b><br />
                    <div class="package">
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation.php.html">		Calculation.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Database.php.html">		Database.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---DateTime.php.html">		DateTime.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Engineering.php.html">		Engineering.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Exception.php.html">		Exception.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---ExceptionHandler.php.html">		ExceptionHandler.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Financial.php.html">		Financial.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---FormulaParser.php.html">		FormulaParser.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---FormulaToken.php.html">		FormulaToken.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Function.php.html">		Function.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Functions.php.html">		Functions.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Logical.php.html">		Logical.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---LookupRef.php.html">		LookupRef.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---MathTrig.php.html">		MathTrig.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---Statistical.php.html">		Statistical.php
                        </a><br>
                        <a href="../PHPExcel_Calculation/_PHPExcel---Calculation---TextData.php.html">		TextData.php
                        </a><br>
                    </div><br />


                    <b>Classes:</b><br />
                    <div class="package">
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation.html">PHPExcel_Calculation</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Database.html">PHPExcel_Calculation_Database</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_DateTime.html">PHPExcel_Calculation_DateTime</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Engineering.html">PHPExcel_Calculation_Engineering</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Exception.html">PHPExcel_Calculation_Exception</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_ExceptionHandler.html">PHPExcel_Calculation_ExceptionHandler</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html">PHPExcel_Calculation_Financial</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_FormulaParser.html">PHPExcel_Calculation_FormulaParser</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_FormulaToken.html">PHPExcel_Calculation_FormulaToken</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Function.html">PHPExcel_Calculation_Function</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Functions.html">PHPExcel_Calculation_Functions</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Logical.html">PHPExcel_Calculation_Logical</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_LookupRef.html">PHPExcel_Calculation_LookupRef</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_MathTrig.html">PHPExcel_Calculation_MathTrig</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_Statistical.html">PHPExcel_Calculation_Statistical</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Calculation_TextData.html">PHPExcel_Calculation_TextData</a><br />
                        <a href="../PHPExcel_Calculation/PHPExcel_Token_Stack.html">PHPExcel_Token_Stack</a><br />
                    </div>
                </td>
                <td>
                    <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

                                <h1>Class: PHPExcel_Calculation_Financial</h1>
                                Source Location: /PHPExcel/Calculation/Financial.php<br /><br />


                                <table width="100%" border="0">
                                    <tr><td valign="top">

                                            <h3><a href="#class_details">Class Overview</a></h3>
                                            <pre></pre><br />
                                            <div class="description">PHPExcel_Calculation_Financial</div><br /><br />
                                            <h4>Author(s):</h4>
                                            <ul>
                                            </ul>







                                            <h4>Copyright:</h4>
                                            <ul>
                                                <li>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</li>
                                            </ul>

                                        </td>



                                        <td valign="top">
                                            <h3><a href="#class_methods">Methods</a></h3>
                                            <ul>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodACCRINT">ACCRINT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodACCRINTM">ACCRINTM</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodAMORDEGRC">AMORDEGRC</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodAMORLINC">AMORLINC</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPDAYBS">COUPDAYBS</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPDAYS">COUPDAYS</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPDAYSNC">COUPDAYSNC</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPNCD">COUPNCD</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPNUM">COUPNUM</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCOUPPCD">COUPPCD</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCUMIPMT">CUMIPMT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodCUMPRINC">CUMPRINC</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDB">DB</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDDB">DDB</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDISC">DISC</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDOLLARDE">DOLLARDE</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodDOLLARFR">DOLLARFR</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodEFFECT">EFFECT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodFV">FV</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodFVSCHEDULE">FVSCHEDULE</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodINTRATE">INTRATE</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodIPMT">IPMT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodIRR">IRR</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodISPMT">ISPMT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodMIRR">MIRR</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodNOMINAL">NOMINAL</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodNPER">NPER</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodNPV">NPV</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPMT">PMT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPPMT">PPMT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPRICE">PRICE</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPRICEDISC">PRICEDISC</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPRICEMAT">PRICEMAT</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodPV">PV</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodRATE">RATE</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodRECEIVED">RECEIVED</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodSLN">SLN</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodSYD">SYD</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodTBILLEQ">TBILLEQ</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodTBILLPRICE">TBILLPRICE</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodTBILLYIELD">TBILLYIELD</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodXIRR">XIRR</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodXNPV">XNPV</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodYIELDDISC">YIELDDISC</a></li>
                                                <li><a href="../PHPExcel_Calculation/PHPExcel_Calculation_Financial.html#methodYIELDMAT">YIELDMAT</a></li>
                                            </ul>
                                        </td>

                                    </tr></table>
                                <hr />

                                <table width="100%" border="0"><tr>






                                    </tr></table>
                                <hr />

                                <a name="class_details"></a>
                                <h3>Class Details</h3>
                                <div class="tags">
                                    [line 53]<br />
                                    PHPExcel_Calculation_Financial<br /><br /><br /><br />
                                    <h4>Tags:</h4>
                                    <div class="tags">
                                        <table border="0" cellspacing="0" cellpadding="0">
                                            <tr>
                                                <td><b>copyright:</b>&nbsp;&nbsp;</td><td>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</td>
                                            </tr>
                                        </table>
                                    </div>
                                </div><br /><br />
                                <div class="top">[ <a href="#top">Top</a> ]</div><br />


                                <hr />
                                <a name="class_methods"></a>
                                <h3>Class Methods</h3>
                                <div class="tags">
                                    <hr />
                                    <a name="methodACCRINT"></a>
                                    <h3>static method ACCRINT <span class="smalllinenumber">[line 201]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float ACCRINT(
                                                                    mixed
                                                                    $issue, mixed
                                                                    $firstinterest, mixed
                                                                    $settlement, float
                                                                    $rate, [float
                                                                    $par = 1000], [integer
                                                                    $frequency = 1], [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        ACCRINT<br /><br /><p>Returns the accrued interest for a security that pays periodic interest.</p><p>Excel Function: 		ACCRINT(issue,firstinterest,settlement,rate,par,frequency[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$issue</b>&nbsp;&nbsp;</td>
                                                    <td>The security's issue date.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$firstinterest</b>&nbsp;&nbsp;</td>
                                                    <td>The security's first interest date.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>The security's settlement date.                                     The security settlement date is the date after the issue date                                     when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>The security's annual coupon rate.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$par</b>&nbsp;&nbsp;</td>
                                                    <td>The security's par value.                                     If you omit par, ACCRINT uses $1,000.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td>the number of coupon payments per year.                                     Valid frequency values are: <ol><li>Annual</li><li>Semi-Annual</li></ol>                                        4    Quarterly                                     If working in Gnumeric Mode, the following frequency options are                                     also available                                         6    Bimonthly                                         12    Monthly</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodACCRINTM"></a>
                                    <h3>static method ACCRINTM <span class="smalllinenumber">[line 253]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float ACCRINTM(
                                                                    mixed
                                                                    $issue, mixed
                                                                    $settlement, float
                                                                    $rate, [float
                                                                    $par = 1000], [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        ACCRINTM<br /><br /><p>Returns the accrued interest for a security that pays interest at maturity.</p><p>Excel Function: 		ACCRINTM(issue,settlement,rate[,par[,basis]])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$issue</b>&nbsp;&nbsp;</td>
                                                    <td>issue        The security's issue date.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement (or maturity) date.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>rate        The security's annual coupon rate.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$par</b>&nbsp;&nbsp;</td>
                                                    <td>par            The security's par value.                                     If you omit par, ACCRINT uses $1,000.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodAMORDEGRC"></a>
                                    <h3>static method AMORDEGRC <span class="smalllinenumber">[line 309]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float AMORDEGRC(
                                                                    float
                                                                    $cost, mixed
                                                                    $purchased, mixed
                                                                    $firstPeriod, mixed
                                                                    $salvage, float
                                                                    $period, float
                                                                    $rate, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        AMORDEGRC<br /><br /><p>Returns the depreciation for each accounting period.  This function is provided for the French accounting system. If an asset is purchased in  the middle of the accounting period, the prorated depreciation is taken into account.  The function is similar to AMORLINC, except that a depreciation coefficient is applied in  the calculation depending on the life of the assets.  This function will return the depreciation until the last period of the life of the assets  or until the cumulated value of depreciation is greater than the cost of the assets minus  the salvage value.</p><p>Excel Function: 		AMORDEGRC(cost,purchased,firstPeriod,salvage,period,rate[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$cost</b>&nbsp;&nbsp;</td>
                                                    <td>cost        The cost of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$purchased</b>&nbsp;&nbsp;</td>
                                                    <td>purchased    Date of the purchase of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$firstPeriod</b>&nbsp;&nbsp;</td>
                                                    <td>firstPeriod    Date of the end of the first period.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$salvage</b>&nbsp;&nbsp;</td>
                                                    <td>salvage        The salvage value at the end of the life of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$period</b>&nbsp;&nbsp;</td>
                                                    <td>period        The period.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>rate        Rate of depreciation.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodAMORLINC"></a>
                                    <h3>static method AMORLINC <span class="smalllinenumber">[line 385]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float AMORLINC(
                                                                    float
                                                                    $cost, mixed
                                                                    $purchased, mixed
                                                                    $firstPeriod, mixed
                                                                    $salvage, float
                                                                    $period, float
                                                                    $rate, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        AMORLINC<br /><br /><p>Returns the depreciation for each accounting period.  This function is provided for the French accounting system. If an asset is purchased in  the middle of the accounting period, the prorated depreciation is taken into account.</p><p>Excel Function: 		AMORLINC(cost,purchased,firstPeriod,salvage,period,rate[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$cost</b>&nbsp;&nbsp;</td>
                                                    <td>cost        The cost of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$purchased</b>&nbsp;&nbsp;</td>
                                                    <td>purchased    Date of the purchase of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$firstPeriod</b>&nbsp;&nbsp;</td>
                                                    <td>firstPeriod    Date of the end of the first period.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$salvage</b>&nbsp;&nbsp;</td>
                                                    <td>salvage        The salvage value at the end of the life of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$period</b>&nbsp;&nbsp;</td>
                                                    <td>period        The period.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>rate        Rate of depreciation.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCOUPDAYBS"></a>
                                    <h3>static method COUPDAYBS <span class="smalllinenumber">[line 451]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float COUPDAYBS(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $frequency, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        COUPDAYBS<br /><br /><p>Returns the number of days from the beginning of the coupon period to the settlement date.</p><p>Excel Function: 		COUPDAYBS(settlement,maturity,frequency[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue                                 date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td>frequency    the number of coupon payments per year.                                     Valid frequency values are: <ol><li>Annual</li><li>Semi-Annual</li></ol>                                        4    Quarterly                                     If working in Gnumeric Mode, the following frequency options are                                     also available                                         6    Bimonthly                                         12    Monthly</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCOUPDAYS"></a>
                                    <h3>static method COUPDAYS <span class="smalllinenumber">[line 509]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float COUPDAYS(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $frequency, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        COUPDAYS<br /><br /><p>Returns the number of days in the coupon period that contains the settlement date.</p><p>Excel Function: 		COUPDAYS(settlement,maturity,frequency[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue                                 date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td>frequency    the number of coupon payments per year.                                     Valid frequency values are: <ol><li>Annual</li><li>Semi-Annual</li></ol>                                        4    Quarterly                                     If working in Gnumeric Mode, the following frequency options are                                     also available                                         6    Bimonthly                                         12    Monthly</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCOUPDAYSNC"></a>
                                    <h3>static method COUPDAYSNC <span class="smalllinenumber">[line 579]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float COUPDAYSNC(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $frequency, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        COUPDAYSNC<br /><br /><p>Returns the number of days from the settlement date to the next coupon date.</p><p>Excel Function: 		COUPDAYSNC(settlement,maturity,frequency[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue                                 date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td>frequency    the number of coupon payments per year.                                     Valid frequency values are: <ol><li>Annual</li><li>Semi-Annual</li></ol>                                        4    Quarterly                                     If working in Gnumeric Mode, the following frequency options are                                     also available                                         6    Bimonthly                                         12    Monthly</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCOUPNCD"></a>
                                    <h3>static method COUPNCD <span class="smalllinenumber">[line 638]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static mixed COUPNCD(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $frequency, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        COUPNCD<br /><br /><p>Returns the next coupon date after the settlement date.</p><p>Excel Function: 		COUPNCD(settlement,maturity,frequency[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Excel date/time serial value, PHP date/time serial value or PHP date/time object,                         depending on the value of the ReturnDateType flag</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue                                 date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td>frequency    the number of coupon payments per year.                                     Valid frequency values are: <ol><li>Annual</li><li>Semi-Annual</li></ol>                                        4    Quarterly                                     If working in Gnumeric Mode, the following frequency options are                                     also available                                         6    Bimonthly                                         12    Monthly</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCOUPNUM"></a>
                                    <h3>static method COUPNUM <span class="smalllinenumber">[line 694]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static integer COUPNUM(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $frequency, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        COUPNUM<br /><br /><p>Returns the number of coupons payable between the settlement date and maturity date,  rounded up to the nearest whole coupon.</p><p>Excel Function: 		COUPNUM(settlement,maturity,frequency[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue                                 date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td>frequency    the number of coupon payments per year.                                     Valid frequency values are: <ol><li>Annual</li><li>Semi-Annual</li></ol>                                        4    Quarterly                                     If working in Gnumeric Mode, the following frequency options are                                     also available                                         6    Bimonthly                                         12    Monthly</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCOUPPCD"></a>
                                    <h3>static method COUPPCD <span class="smalllinenumber">[line 765]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static mixed COUPPCD(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $frequency, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        COUPPCD<br /><br /><p>Returns the previous coupon date before the settlement date.</p><p>Excel Function: 		COUPPCD(settlement,maturity,frequency[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Excel date/time serial value, PHP date/time serial value or PHP date/time object,                         depending on the value of the ReturnDateType flag</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue                                 date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td>frequency    the number of coupon payments per year.                                     Valid frequency values are: <ol><li>Annual</li><li>Semi-Annual</li></ol>                                        4    Quarterly                                     If working in Gnumeric Mode, the following frequency options are                                     also available                                         6    Bimonthly                                         12    Monthly</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCUMIPMT"></a>
                                    <h3>static method CUMIPMT <span class="smalllinenumber">[line 809]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float CUMIPMT(
                                                                    float
                                                                    $rate, integer
                                                                    $nper, float
                                                                    $pv, integer
                                                                    $start, integer
                                                                    $end, [integer
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        CUMIPMT<br /><br /><p>Returns the cumulative interest paid on a loan between the start and end periods.</p><p>Excel Function: 		CUMIPMT(rate,nper,pv,start,end[,type])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>The Interest rate</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>The total number of payment periods</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>Present Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$start</b>&nbsp;&nbsp;</td>
                                                    <td>The first period in the calculation.                             Payment periods are numbered beginning with 1.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$end</b>&nbsp;&nbsp;</td>
                                                    <td>The last period in the calculation.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>A number 0 or 1 and indicates when payments are due: <ol><li>or omitted    At the end of the period.</li><li>At the beginning of the period.</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodCUMPRINC"></a>
                                    <h3>static method CUMPRINC <span class="smalllinenumber">[line 856]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float CUMPRINC(
                                                                    float
                                                                    $rate, integer
                                                                    $nper, float
                                                                    $pv, integer
                                                                    $start, integer
                                                                    $end, [integer
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        CUMPRINC<br /><br /><p>Returns the cumulative principal paid on a loan between the start and end periods.</p><p>Excel Function: 		CUMPRINC(rate,nper,pv,start,end[,type])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>The Interest rate</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>The total number of payment periods</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>Present Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$start</b>&nbsp;&nbsp;</td>
                                                    <td>The first period in the calculation.                             Payment periods are numbered beginning with 1.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$end</b>&nbsp;&nbsp;</td>
                                                    <td>The last period in the calculation.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>A number 0 or 1 and indicates when payments are due: <ol><li>or omitted    At the end of the period.</li><li>At the beginning of the period.</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodDB"></a>
                                    <h3>static method DB <span class="smalllinenumber">[line 908]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float DB(
                                                                    float
                                                                    $cost, float
                                                                    $salvage, integer
                                                                    $life, integer
                                                                    $period, [integer
                                                                    $month = 12])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        DB<br /><br /><p>Returns the depreciation of an asset for a specified period using the  fixed-declining balance method.  This form of depreciation is used if you want to get a higher depreciation value  at the beginning of the depreciation (as opposed to linear depreciation). The  depreciation value is reduced with every depreciation period by the depreciation  already deducted from the initial cost.</p><p>Excel Function: 		DB(cost,salvage,life,period[,month])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$cost</b>&nbsp;&nbsp;</td>
                                                    <td>cost        Initial cost of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$salvage</b>&nbsp;&nbsp;</td>
                                                    <td>salvage        Value at the end of the depreciation.                                 (Sometimes called the salvage value of the asset)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$life</b>&nbsp;&nbsp;</td>
                                                    <td>life        Number of periods over which the asset is depreciated.                                 (Sometimes called the useful life of the asset)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$period</b>&nbsp;&nbsp;</td>
                                                    <td>period        The period for which you want to calculate the                                 depreciation. Period must use the same units as life.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$month</b>&nbsp;&nbsp;</td>
                                                    <td>month        Number of months in the first year. If month is omitted,                                 it defaults to 12.</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodDDB"></a>
                                    <h3>static method DDB <span class="smalllinenumber">[line 975]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float DDB(
                                                                    float
                                                                    $cost, float
                                                                    $salvage, integer
                                                                    $life, integer
                                                                    $period, [float
                                                                    $factor = 2.0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        DDB<br /><br /><p>Returns the depreciation of an asset for a specified period using the  double-declining balance method or some other method you specify.</p><p>Excel Function: 		DDB(cost,salvage,life,period[,factor])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$cost</b>&nbsp;&nbsp;</td>
                                                    <td>cost        Initial cost of the asset.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$salvage</b>&nbsp;&nbsp;</td>
                                                    <td>salvage        Value at the end of the depreciation.                                 (Sometimes called the salvage value of the asset)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$life</b>&nbsp;&nbsp;</td>
                                                    <td>life        Number of periods over which the asset is depreciated.                                 (Sometimes called the useful life of the asset)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$period</b>&nbsp;&nbsp;</td>
                                                    <td>period        The period for which you want to calculate the                                 depreciation. Period must use the same units as life.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$factor</b>&nbsp;&nbsp;</td>
                                                    <td>factor        The rate at which the balance declines.                                 If factor is omitted, it is assumed to be 2 (the                                 double-declining balance method).</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodDISC"></a>
                                    <h3>static method DISC <span class="smalllinenumber">[line 1036]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float DISC(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, integer
                                                                    $price, integer
                                                                    $redemption, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        DISC<br /><br /><p>Returns the discount rate for a security.</p><p>Excel Function: 		DISC(settlement,maturity,price,redemption[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue                                 date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$price</b>&nbsp;&nbsp;</td>
                                                    <td>price        The security's price per $100 face value.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$redemption</b>&nbsp;&nbsp;</td>
                                                    <td>redemption    The security's redemption value per $100 face value.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodDOLLARDE"></a>
                                    <h3>static method DOLLARDE <span class="smalllinenumber">[line 1079]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float DOLLARDE(
                                                                    [float
                                                                    $fractional_dollar = Null], [integer
                                                                    $fraction = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        DOLLARDE<br /><br /><p>Converts a dollar price expressed as an integer part and a fraction 		part into a dollar price expressed as a decimal number.  Fractional dollar numbers are sometimes used for security prices.</p><p>Excel Function: 		DOLLARDE(fractional_dollar,fraction)</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$fractional_dollar</b>&nbsp;&nbsp;</td>
                                                    <td>Fractional Dollar</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$fraction</b>&nbsp;&nbsp;</td>
                                                    <td>Fraction</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodDOLLARFR"></a>
                                    <h3>static method DOLLARFR <span class="smalllinenumber">[line 1115]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float DOLLARFR(
                                                                    [float
                                                                    $decimal_dollar = Null], [integer
                                                                    $fraction = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        DOLLARFR<br /><br /><p>Converts a dollar price expressed as a decimal number into a dollar price 		expressed as a fraction.  Fractional dollar numbers are sometimes used for security prices.</p><p>Excel Function: 		DOLLARFR(decimal_dollar,fraction)</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$decimal_dollar</b>&nbsp;&nbsp;</td>
                                                    <td>Decimal Dollar</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$fraction</b>&nbsp;&nbsp;</td>
                                                    <td>Fraction</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodEFFECT"></a>
                                    <h3>static method EFFECT <span class="smalllinenumber">[line 1150]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float EFFECT(
                                                                    [float
                                                                    $nominal_rate = 0], [integer
                                                                    $npery = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        EFFECT<br /><br /><p>Returns the effective interest rate given the nominal rate and the number of 		compounding payments per year.</p><p>Excel Function: 		EFFECT(nominal_rate,npery)</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$nominal_rate</b>&nbsp;&nbsp;</td>
                                                    <td>Nominal interest rate</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$npery</b>&nbsp;&nbsp;</td>
                                                    <td>Number of compounding payments per year</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodFV"></a>
                                    <h3>static method FV <span class="smalllinenumber">[line 1185]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float FV(
                                                                    [float
                                                                    $rate = 0], [int
                                                                    $nper = 0], [float
                                                                    $pmt = 0], [float
                                                                    $pv = 0], [integer
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        FV<br /><br /><p>Returns the Future Value of a cash flow with constant payments and interest rate (annuities).</p><p>Excel Function: 		FV(rate,nper,pmt[,pv[,type]])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>The interest rate per period</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>Total number of payment periods in an annuity</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pmt</b>&nbsp;&nbsp;</td>
                                                    <td>The payment made each period: it cannot change over the                             life of the annuity. Typically, pmt contains principal                             and interest but no other fees or taxes.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>Present Value, or the lump-sum amount that a series of                             future payments is worth right now.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>A number 0 or 1 and indicates when payments are due: <ol><li>or omitted    At the end of the period.</li><li>At the beginning of the period.</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodFVSCHEDULE"></a>
                                    <h3>static method FVSCHEDULE <span class="smalllinenumber">[line 1210]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static void FVSCHEDULE(

                                                                    $principal, 
                                                                    $schedule)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        FVSCHEDULE<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$principal</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$schedule</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodINTRATE"></a>
                                    <h3>static method INTRATE <span class="smalllinenumber">[line 1244]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float INTRATE(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, integer
                                                                    $investment, integer
                                                                    $redemption, [integer
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        INTRATE<br /><br /><p>Returns the interest rate for a fully invested security.</p><p>Excel Function: 		INTRATE(settlement,maturity,investment,redemption[,basis])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$investment</b>&nbsp;&nbsp;</td>
                                                    <td>investment    The amount invested in the security.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$redemption</b>&nbsp;&nbsp;</td>
                                                    <td>redemption    The amount to be received at maturity.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodIPMT"></a>
                                    <h3>static method IPMT <span class="smalllinenumber">[line 1284]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float IPMT(
                                                                    float
                                                                    $rate, int
                                                                    $per, int
                                                                    $nper, float
                                                                    $pv, [float
                                                                    $fv = 0], [int
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        IPMT<br /><br /><p>Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>Interest rate per period</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$per</b>&nbsp;&nbsp;</td>
                                                    <td>Period for which we want to find the interest</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>Number of periods</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>Present Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$fv</b>&nbsp;&nbsp;</td>
                                                    <td>Future Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>Payment type: 0 = at the end of each period, 1 = at the beginning of each period</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodIRR"></a>
                                    <h3>static method IRR <span class="smalllinenumber">[line 1306]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static void IRR(

                                                                    $values, [
                                                                    $guess = 0.1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        <br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$values</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$guess</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodISPMT"></a>
                                    <h3>static method ISPMT <span class="smalllinenumber">[line 1362]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static void ISPMT(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        ISPMT<br /><br /><p>Returns the interest payment for an investment based on an interest rate and a constant payment schedule.</p><p>Excel Function:           =ISPMT(interest_rate, period, number_payments, PV)</p><p>interest_rate is the interest rate for the investment</p><p>period is the period to calculate the interest rate.  It must be betweeen 1 and number_payments.</p><p>number_payments is the number of payments for the annuity</p><p>PV is the loan amount or present value of the payments</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodMIRR"></a>
                                    <h3>static method MIRR <span class="smalllinenumber">[line 1387]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static void MIRR(

                                                                    $values, 
                                                                    $finance_rate, 
                                                                    $reinvestment_rate)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        <br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$values</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$finance_rate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$reinvestment_rate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodNOMINAL"></a>
                                    <h3>static method NOMINAL <span class="smalllinenumber">[line 1426]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float NOMINAL(
                                                                    [float
                                                                    $effect_rate = 0], [int
                                                                    $npery = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        NOMINAL<br /><br /><p>Returns the nominal interest rate given the effective rate and the number of compounding payments per year.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$effect_rate</b>&nbsp;&nbsp;</td>
                                                    <td>Effective interest rate</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$npery</b>&nbsp;&nbsp;</td>
                                                    <td>Number of compounding payments per year</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodNPER"></a>
                                    <h3>static method NPER <span class="smalllinenumber">[line 1452]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float NPER(
                                                                    [float
                                                                    $rate = 0], [int
                                                                    $pmt = 0], [float
                                                                    $pv = 0], [float
                                                                    $fv = 0], [int
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        NPER<br /><br /><p>Returns the number of periods for a cash flow with constant periodic payments (annuities), and interest rate.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>Interest rate per period</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pmt</b>&nbsp;&nbsp;</td>
                                                    <td>Periodic payment (annuity)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>Present Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$fv</b>&nbsp;&nbsp;</td>
                                                    <td>Future Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>Payment type: 0 = at the end of each period, 1 = at the beginning of each period</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodNPV"></a>
                                    <h3>static method NPV <span class="smalllinenumber">[line 1488]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float NPV(
                                                                    float
                                                                    0, array
                                                                    1)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        NPV<br /><br /><p>Returns the Net Present Value of a cash flow series given a discount rate.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>0</b>&nbsp;&nbsp;</td>
                                                    <td>Discount interest rate</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>1</b>&nbsp;&nbsp;</td>
                                                    <td>Cash flow series</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodPMT"></a>
                                    <h3>static method PMT <span class="smalllinenumber">[line 1521]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float PMT(
                                                                    [float
                                                                    $rate = 0], [int
                                                                    $nper = 0], [float
                                                                    $pv = 0], [float
                                                                    $fv = 0], [int
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        PMT<br /><br /><p>Returns the constant payment (annuity) for a cash flow with a constant interest rate.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>Interest rate per period</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>Number of periods</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>Present Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$fv</b>&nbsp;&nbsp;</td>
                                                    <td>Future Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>Payment type: 0 = at the end of each period, 1 = at the beginning of each period</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodPPMT"></a>
                                    <h3>static method PPMT <span class="smalllinenumber">[line 1555]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float PPMT(
                                                                    float
                                                                    $rate, int
                                                                    $per, int
                                                                    $nper, float
                                                                    $pv, [float
                                                                    $fv = 0], [int
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        PPMT<br /><br /><p>Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>Interest rate per period</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$per</b>&nbsp;&nbsp;</td>
                                                    <td>Period for which we want to find the interest</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>Number of periods</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>Present Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$fv</b>&nbsp;&nbsp;</td>
                                                    <td>Future Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>Payment type: 0 = at the end of each period, 1 = at the beginning of each period</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodPRICE"></a>
                                    <h3>static method PRICE <span class="smalllinenumber">[line 1577]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static void PRICE(

                                                                    $settlement, 
                                                                    $maturity, 
                                                                    $rate, 
                                                                    $yield, 
                                                                    $redemption, 
                                                                    $frequency, [
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        <br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$yield</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$redemption</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$frequency</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodPRICEDISC"></a>
                                    <h3>static method PRICEDISC <span class="smalllinenumber">[line 1637]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float PRICEDISC(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, int
                                                                    $discount, int
                                                                    $redemption, [int
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        PRICEDISC<br /><br /><p>Returns the price per $100 face value of a discounted security.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$discount</b>&nbsp;&nbsp;</td>
                                                    <td>discount    The security's discount rate.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$redemption</b>&nbsp;&nbsp;</td>
                                                    <td>redemption    The security's redemption value per $100 face value.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodPRICEMAT"></a>
                                    <h3>static method PRICEMAT <span class="smalllinenumber">[line 1681]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float PRICEMAT(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $issue, int
                                                                    $rate, int
                                                                    $yield, [int
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        PRICEMAT<br /><br /><p>Returns the price per $100 face value of a security that pays interest at maturity.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security's settlement date is the date after the issue date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$issue</b>&nbsp;&nbsp;</td>
                                                    <td>issue        The security's issue date.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>rate        The security's interest rate at date of issue.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$yield</b>&nbsp;&nbsp;</td>
                                                    <td>yield        The security's annual yield.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodPV"></a>
                                    <h3>static method PV <span class="smalllinenumber">[line 1737]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float PV(
                                                                    [float
                                                                    $rate = 0], [int
                                                                    $nper = 0], [float
                                                                    $pmt = 0], [float
                                                                    $fv = 0], [int
                                                                    $type = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        PV<br /><br /><p>Returns the Present Value of a cash flow with constant payments and interest rate (annuities).</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>Interest rate per period</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>Number of periods</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pmt</b>&nbsp;&nbsp;</td>
                                                    <td>Periodic payment (annuity)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$fv</b>&nbsp;&nbsp;</td>
                                                    <td>Future Value</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>Payment type: 0 = at the end of each period, 1 = at the beginning of each period</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodRATE"></a>
                                    <h3>static method RATE <span class="smalllinenumber">[line 1788]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float RATE(
                                                                    float
                                                                    $nper, float
                                                                    $pmt, float
                                                                    $pv, [float
                                                                    $fv = 0.0], [integer
                                                                    $type = 0], [float
                                                                    $guess = 0.1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        RATE<br /><br /><p>Returns the interest rate per period of an annuity.  RATE is calculated by iteration and can have zero or more solutions.  If the successive results of RATE do not converge to within 0.0000001 after 20 iterations,  RATE returns the #NUM! error value.</p><p>Excel Function: 		RATE(nper,pmt,pv[,fv[,type[,guess]]])</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$nper</b>&nbsp;&nbsp;</td>
                                                    <td>nper        The total number of payment periods in an annuity.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pmt</b>&nbsp;&nbsp;</td>
                                                    <td>pmt            The payment made each period and cannot change over the life                                     of the annuity.                                 Typically, pmt includes principal and interest but no other                                     fees or taxes.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$pv</b>&nbsp;&nbsp;</td>
                                                    <td>pv            The present value - the total amount that a series of future                                     payments is worth now.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$fv</b>&nbsp;&nbsp;</td>
                                                    <td>fv            The future value, or a cash balance you want to attain after                                     the last payment is made. If fv is omitted, it is assumed                                     to be 0 (the future value of a loan, for example, is 0).</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$type</b>&nbsp;&nbsp;</td>
                                                    <td>type        A number 0 or 1 and indicates when payments are due: <ol><li>or omitted    At the end of the period.</li><li>At the beginning of the period.</li></ol></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$guess</b>&nbsp;&nbsp;</td>
                                                    <td>guess        Your guess for what the rate will be.                                     If you omit guess, it is assumed to be 10 percent.</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodRECEIVED"></a>
                                    <h3>static method RECEIVED <span class="smalllinenumber">[line 1850]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float RECEIVED(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, int
                                                                    $investment, int
                                                                    $discount, [int
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        RECEIVED<br /><br /><p>Returns the price per $100 face value of a discounted security.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security settlement date is the date after the issue date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$investment</b>&nbsp;&nbsp;</td>
                                                    <td>investment    The amount invested in the security.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$discount</b>&nbsp;&nbsp;</td>
                                                    <td>discount    The security's discount rate.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodSLN"></a>
                                    <h3>static method SLN <span class="smalllinenumber">[line 1884]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float SLN(
                                                                    cost
                                                                    $cost, salvage
                                                                    $salvage, life
                                                                    $life)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        SLN<br /><br /><p>Returns the straight-line depreciation of an asset for one period</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">cost&nbsp;&nbsp;</td>
                                                    <td><b>$cost</b>&nbsp;&nbsp;</td>
                                                    <td>Initial cost of the asset</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">salvage&nbsp;&nbsp;</td>
                                                    <td><b>$salvage</b>&nbsp;&nbsp;</td>
                                                    <td>Value at the end of the depreciation</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">life&nbsp;&nbsp;</td>
                                                    <td><b>$life</b>&nbsp;&nbsp;</td>
                                                    <td>Number of periods over which the asset is depreciated</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodSYD"></a>
                                    <h3>static method SYD <span class="smalllinenumber">[line 1911]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float SYD(
                                                                    cost
                                                                    $cost, salvage
                                                                    $salvage, life
                                                                    $life, period
                                                                    $period)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        SYD<br /><br /><p>Returns the sum-of-years' digits depreciation of an asset for a specified period.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">cost&nbsp;&nbsp;</td>
                                                    <td><b>$cost</b>&nbsp;&nbsp;</td>
                                                    <td>Initial cost of the asset</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">salvage&nbsp;&nbsp;</td>
                                                    <td><b>$salvage</b>&nbsp;&nbsp;</td>
                                                    <td>Value at the end of the depreciation</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">life&nbsp;&nbsp;</td>
                                                    <td><b>$life</b>&nbsp;&nbsp;</td>
                                                    <td>Number of periods over which the asset is depreciated</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">period&nbsp;&nbsp;</td>
                                                    <td><b>$period</b>&nbsp;&nbsp;</td>
                                                    <td>Period</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodTBILLEQ"></a>
                                    <h3>static method TBILLEQ <span class="smalllinenumber">[line 1940]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float TBILLEQ(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, int
                                                                    $discount)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        TBILLEQ<br /><br /><p>Returns the bond-equivalent yield for a Treasury bill.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The Treasury bill's settlement date.                                 The Treasury bill's settlement date is the date after the issue date when the Treasury bill is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The Treasury bill's maturity date.                                 The maturity date is the date when the Treasury bill expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$discount</b>&nbsp;&nbsp;</td>
                                                    <td>discount    The Treasury bill's discount rate.</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodTBILLPRICE"></a>
                                    <h3>static method TBILLPRICE <span class="smalllinenumber">[line 1978]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float TBILLPRICE(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, int
                                                                    $discount)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        TBILLPRICE<br /><br /><p>Returns the yield for a Treasury bill.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The Treasury bill's settlement date.                                 The Treasury bill's settlement date is the date after the issue date when the Treasury bill is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The Treasury bill's maturity date.                                 The maturity date is the date when the Treasury bill expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$discount</b>&nbsp;&nbsp;</td>
                                                    <td>discount    The Treasury bill's discount rate.</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodTBILLYIELD"></a>
                                    <h3>static method TBILLYIELD <span class="smalllinenumber">[line 2030]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float TBILLYIELD(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, int
                                                                    $price)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        TBILLYIELD<br /><br /><p>Returns the yield for a Treasury bill.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The Treasury bill's settlement date.                                 The Treasury bill's settlement date is the date after the issue date when the Treasury bill is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The Treasury bill's maturity date.                                 The maturity date is the date when the Treasury bill expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$price</b>&nbsp;&nbsp;</td>
                                                    <td>price        The Treasury bill's price per $100 face value.</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodXIRR"></a>
                                    <h3>static method XIRR <span class="smalllinenumber">[line 2062]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static void XIRR(

                                                                    $values, 
                                                                    $dates, [
                                                                    $guess = 0.1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        <br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$values</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$dates</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">&nbsp;&nbsp;</td>
                                                    <td><b>$guess</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodXNPV"></a>
                                    <h3>static method XNPV <span class="smalllinenumber">[line 2118]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float XNPV(
                                                                    float
                                                                    $rate, array
                                                                    $values, array
                                                                    $dates)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        XNPV<br /><br /><p>Returns the net present value for a schedule of cash flows that is not necessarily periodic.  To calculate the net present value for a series of cash flows that is periodic, use the NPV function.</p><p>Excel Function: 		=XNPV(rate,values,dates)</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">float&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>The discount rate to apply to the cash flows.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>$values</b>&nbsp;&nbsp;</td>
                                                    <td>of float    $values        A series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. The series of values must contain at least one positive value and one negative value.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>$dates</b>&nbsp;&nbsp;</td>
                                                    <td>of mixed    $dates        A schedule of payment dates that corresponds to the cash flow payments. The first payment date indicates the beginning of the schedule of payments. All other dates must be later than this date, but they may occur in any order.</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodYIELDDISC"></a>
                                    <h3>static method YIELDDISC <span class="smalllinenumber">[line 2156]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float YIELDDISC(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, int
                                                                    $price, int
                                                                    $redemption, [int
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        YIELDDISC<br /><br /><p>Returns the annual yield of a security that pays interest at maturity.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security's settlement date is the date after the issue date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$price</b>&nbsp;&nbsp;</td>
                                                    <td>price        The security's price per $100 face value.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$redemption</b>&nbsp;&nbsp;</td>
                                                    <td>redemption    The security's redemption value per $100 face value.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodYIELDMAT"></a>
                                    <h3>static method YIELDMAT <span class="smalllinenumber">[line 2205]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static float YIELDMAT(
                                                                    mixed
                                                                    $settlement, mixed
                                                                    $maturity, mixed
                                                                    $issue, int
                                                                    $rate, int
                                                                    $price, [int
                                                                    $basis = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        YIELDMAT<br /><br /><p>Returns the annual yield of a security that pays interest at maturity.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$settlement</b>&nbsp;&nbsp;</td>
                                                    <td>settlement    The security's settlement date.                                 The security's settlement date is the date after the issue date when the security is traded to the buyer.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$maturity</b>&nbsp;&nbsp;</td>
                                                    <td>maturity    The security's maturity date.                                 The maturity date is the date when the security expires.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$issue</b>&nbsp;&nbsp;</td>
                                                    <td>issue        The security's issue date.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$rate</b>&nbsp;&nbsp;</td>
                                                    <td>rate        The security's interest rate at date of issue.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$price</b>&nbsp;&nbsp;</td>
                                                    <td>price        The security's price per $100 face value.</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$basis</b>&nbsp;&nbsp;</td>
                                                    <td>basis        The type of day count to use. <ol><li>or omitted    US (NASD) 30/360</li><li>Actual/actual</li><li>Actual/360</li><li>Actual/365</li><li>European 30/360</li></ol></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>

                                </div><br />


                                <div class="credit">
                                    <hr />
                                    Documentation generated on Sat, 19 May 2012 14:34:45 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.4.4</a>
                                </div>
                            </td></tr></table>
                </td>
            </tr>
        </table>

    </body>
</html>